EDA Profile

Dataset statistics

Number of variables	12
Number of observations	2774
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.7 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `unique_basket_size`	High correlation
`basket_size` is highly overall correlated with `revenue` and 1 other fields	High correlation
`distinct_stock_code` is highly overall correlated with `revenue` and 3 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`revenue` is highly overall correlated with `basket_size` and 3 other fields	High correlation
`total_products` is highly overall correlated with `basket_size` and 3 other fields	High correlation
`total_purchases` is highly overall correlated with `distinct_stock_code` and 2 other fields	High correlation
`unique_basket_size` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`basket_size` is highly skewed (γ1 = 44.87225707)	Skewed
`avg_ticket` is highly skewed (γ1 = 51.90076813)	Skewed
`frequency` is highly skewed (γ1 = 46.08548575)	Skewed
`returned` is highly skewed (γ1 = 50.10197766)	Skewed
`customer_id` has unique values	Unique
`recency` has 34 (1.2%) zeros	Zeros
`returned` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2024-05-24 23:33:59.448847
Analysis finished	2024-05-24 23:34:45.848895
Duration	46.4 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2774
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.7

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.65
Q1	13815.25
median	15242.5
Q3	16779.75
95-th percentile	17950.35
Maximum	18287
Range	5940
Interquartile range (IQR)	2964.5

Descriptive statistics

Standard deviation	1714.9849
Coefficient of variation (CV)	0.11219538
Kurtosis	-1.2069151
Mean	15285.7
Median Absolute Deviation (MAD)	1483.5
Skewness	0.015990788
Sum	42402531
Variance	2941173.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14482	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
Other values (2764)	2764	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2760
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2904.6492

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.557
Q1	628.195
median	1170.87
Q3	2423.86
95-th percentile	7579.4915
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.665

Descriptive statistics

Standard deviation	10927.083
Coefficient of variation (CV)	3.7619287
Kurtosis	331.96378
Mean	2904.6492
Median Absolute Deviation (MAD)	690.475
Skewness	16.261241
Sum	8057496.7
Variance	1.1940114 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
745.06	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
2053.02	2	0.1%
379.65	2	0.1%
1314.45	2	0.1%
331	2	0.1%
Other values (2750)	2754	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency
Real number (ℝ)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.627974

Minimum	0
Maximum	372
Zeros	34
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.419023
Coefficient of variation (CV)	1.2082195
Kurtosis	3.4321191
Mean	56.627974
Median Absolute Deviation (MAD)	23.5
Skewness	1.8983643
Sum	157086
Variance	4681.1627
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2027	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1155
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.801889

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.241667
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.758333

Descriptive statistics

Standard deviation	66.515011
Coefficient of variation (CV)	0.84407889
Kurtosis	3.6744362
Mean	78.801889
Median Absolute Deviation (MAD)	30
Skewness	1.8283611
Sum	218596.44
Variance	4424.2467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
31	16	0.6%
91	16	0.6%
49	16	0.6%
21	15	0.5%
42	15	0.5%
35	15	0.5%
14	14	0.5%
Other values (1145)	2611	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

total_products
Real number (ℝ)

HIGH CORRELATION

Distinct	1632
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1697.8205

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330.25
median	699.5
Q3	1478
95-th percentile	4645.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1147.75

Descriptive statistics

Standard deviation	6074.4301
Coefficient of variation (CV)	3.5777812
Kurtosis	438.72722
Mean	1697.8205
Median Absolute Deviation (MAD)	449
Skewness	17.339197
Sum	4709754
Variance	36898701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
200	7	0.3%
219	7	0.3%
260	7	0.3%
394	7	0.3%
272	7	0.3%
516	7	0.3%
300	7	0.3%
Other values (1622)	2698	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

distinct_stock_code
Real number (ℝ)

HIGH CORRELATION

Distinct	341
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.28659

Minimum	1
Maximum	1785
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	29
median	57
Q3	105
95-th percentile	239.35
Maximum	1785
Range	1784
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	98.70732
Coefficient of variation (CV)	1.1851526
Kurtosis	80.510195
Mean	83.28659
Median Absolute Deviation (MAD)	33
Skewness	6.3465016
Sum	231037
Variance	9743.1349
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	38	1.4%
24	37	1.3%
33	36	1.3%
26	36	1.3%
25	34	1.2%
18	33	1.2%
28	33	1.2%
30	32	1.2%
27	30	1.1%
23	29	1.0%
Other values (331)	2436	87.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	0.7%
2	13	0.5%
3	18	0.6%
4	18	0.6%
5	23	0.8%
6	19	0.7%
7	21	0.8%
8	24	0.9%
9	24	0.9%
10	19	0.7%

Value	Count	Frequency (%)
1785	1	< 0.1%
1765	1	< 0.1%
1321	1	< 0.1%
1118	1	< 0.1%
883	1	< 0.1%
817	1	< 0.1%
717	1	< 0.1%
713	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

total_purchases
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0529921

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.071603
Coefficient of variation (CV)	1.4986973
Kurtosis	183.94516
Mean	6.0529921
Median Absolute Deviation (MAD)	2
Skewness	10.624664
Sum	16791
Variance	82.293981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1932
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	245.46514

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.33333
median	172
Q3	278.17381
95-th percentile	585.55
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	174.84048

Descriptive statistics

Standard deviation	808.02308
Coefficient of variation (CV)	3.2918039
Kurtosis	2224.0987
Mean	245.46514
Median Absolute Deviation (MAD)	81
Skewness	44.872257
Sum	680920.29
Variance	652901.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
82	7	0.3%
208	7	0.3%
105	7	0.3%
136	7	0.3%
197	7	0.3%
73	7	0.3%
Other values (1922)	2696	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%

unique_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1003
Distinct (%)	36.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.122355

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10.127083
median	17.296703
Q3	28.083333
95-th percentile	56.64697
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.95625

Descriptive statistics

Standard deviation	18.868378
Coefficient of variation (CV)	0.85290999
Kurtosis	24.16784
Mean	22.122355
Median Absolute Deviation (MAD)	8.2967033
Skewness	3.1572707
Sum	61367.414
Variance	356.01568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	44	1.6%
14	31	1.1%
11	29	1.0%
9	26	0.9%
1	26	0.9%
17.5	25	0.9%
10.5	25	0.9%
7.5	25	0.9%
9.5	24	0.9%
18	24	0.9%
Other values (993)	2495	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	0.9%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	21	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
203.5	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%
110.3333333	1	< 0.1%
109.6666667	2	0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2772
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.33923

Minimum	2.1505882
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.8527022
Q1	12.426548
median	17.946876
Q3	25.074658
95-th percentile	88.427443
Maximum	56157.5
Range	56155.349
Interquartile range (IQR)	12.64811

Descriptive statistics

Standard deviation	1071.0491
Coefficient of variation (CV)	20.463601
Kurtosis	2718.3215
Mean	52.33923
Median Absolute Deviation (MAD)	6.3338406
Skewness	51.900768
Sum	145189.02
Variance	1147146.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
6.269700855	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
17.98461538	1	< 0.1%
Other values (2762)	2762	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049692192

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0087463557
Q1	0.015758392
median	0.024390244
Q3	0.041666667
95-th percentile	0.11538462
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.025908275

Descriptive statistics

Standard deviation	0.337595
Coefficient of variation (CV)	6.7937233
Kurtosis	2296.5219
Mean	0.049692192
Median Absolute Deviation (MAD)	0.010694545
Skewness	46.085486
Sum	137.84614
Variance	0.11397038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	17	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.07692307692	13	0.5%
0.02127659574	13	0.5%
0.02564102564	13	0.5%
Other values (1215)	2627	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

returned
Real number (ℝ)

SKEWED ZEROS

Distinct	205
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.158976

Minimum	0
Maximum	80995
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	98
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1564.3935
Coefficient of variation (CV)	24.383081
Kurtosis	2586.2541
Mean	64.158976
Median Absolute Deviation (MAD)	0
Skewness	50.101978
Sum	177977
Variance	2447327.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (195)	653	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

Auto

Heatmap
Table

	avg_recency_days	avg_ticket	basket_size	customer_id	distinct_stock_code	frequency	recency	returned	revenue	total_products	total_purchases	unique_basket_size
avg_recency_days	1.000	-0.079	-0.042	-0.012	-0.222	-0.952	0.223	-0.214	-0.366	-0.342	-0.477	0.061
avg_ticket	-0.079	1.000	0.199	-0.141	-0.465	0.081	0.034	0.189	0.274	0.196	0.090	-0.627
basket_size	-0.042	0.199	1.000	-0.120	0.398	0.025	-0.104	0.215	0.602	0.759	0.125	0.431
customer_id	-0.012	-0.141	-0.120	1.000	0.008	0.013	0.013	-0.058	-0.085	-0.078	0.013	0.006
distinct_stock_code	-0.222	-0.465	0.398	0.008	1.000	0.142	-0.335	0.281	0.633	0.632	0.544	0.798
frequency	-0.952	0.081	0.025	0.013	0.142	1.000	-0.126	0.175	0.258	0.239	0.322	-0.070
recency	0.223	0.034	-0.104	0.013	-0.335	-0.126	1.000	-0.187	-0.374	-0.366	-0.447	-0.104
returned	-0.214	0.189	0.215	-0.058	0.281	0.175	-0.187	1.000	0.462	0.427	0.425	0.026
revenue	-0.366	0.274	0.602	-0.085	0.633	0.258	-0.374	0.462	1.000	0.922	0.762	0.281
total_products	-0.342	0.196	0.759	-0.078	0.632	0.239	-0.366	0.427	0.922	1.000	0.703	0.311
total_purchases	-0.477	0.090	0.125	0.013	0.544	0.322	-0.447	0.425	0.762	0.703	1.000	0.017
unique_basket_size	0.061	-0.627	0.431	0.006	0.798	-0.070	-0.104	0.026	0.281	0.311	0.017	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	revenue	recency	avg_recency_days	total_products	distinct_stock_code	total_purchases	basket_size	unique_basket_size	avg_ticket	frequency	returned
0	17850	5391.21	372.0	1.000000	1733.0	21.0	34.0	50.970588	8.735294	18.152222	17.000000	40.0
1	13047	3232.59	56.0	52.833333	1390.0	105.0	9.0	154.444444	19.000000	18.904035	0.028302	35.0
2	12583	6705.38	2.0	26.500000	5028.0	114.0	15.0	335.200000	15.466667	28.902500	0.040323	50.0
3	13748	948.25	95.0	92.666667	439.0	24.0	5.0	87.800000	5.600000	33.866071	0.017921	0.0
4	15100	876.00	333.0	20.000000	80.0	1.0	3.0	26.666667	1.000000	292.000000	0.073171	22.0
5	15291	4623.30	25.0	26.769231	2102.0	61.0	14.0	150.142857	7.285714	45.326471	0.040115	29.0
6	14688	5630.87	7.0	19.263158	3621.0	148.0	21.0	172.428571	15.571429	17.219786	0.057221	399.0
7	17809	5411.91	16.0	39.666667	2057.0	46.0	12.0	171.416667	5.083333	88.719836	0.033520	41.0
8	15311	60767.90	0.0	4.191011	38194.0	567.0	91.0	419.714286	26.142857	25.543464	0.243316	474.0
9	16098	2005.63	87.0	47.666667	613.0	34.0	7.0	87.571429	9.571429	29.934776	0.024390	0.0

	customer_id	revenue	recency	avg_recency_days	total_products	distinct_stock_code	total_purchases	basket_size	unique_basket_size	avg_ticket	frequency	returned
5611	17290	525.24	3.0	13.0	404.0	92.0	2.0	202.000000	51.0	5.149412	0.142857	0.0
5620	14785	77.40	10.0	5.0	84.0	2.0	2.0	42.000000	1.5	25.800000	0.333333	0.0
5621	17254	272.44	4.0	11.0	252.0	100.0	2.0	126.000000	56.0	2.432500	0.166667	0.0
5637	17232	421.52	2.0	12.0	203.0	30.0	2.0	101.500000	18.0	11.708889	0.153846	0.0
5638	17468	137.00	10.0	4.0	116.0	5.0	2.0	58.000000	2.5	27.400000	0.400000	0.0
5649	13596	697.04	5.0	7.0	406.0	133.0	2.0	203.000000	83.0	4.199036	0.250000	0.0
5655	14893	1237.85	9.0	2.0	799.0	72.0	2.0	399.500000	36.5	16.956849	0.666667	0.0
5680	14126	706.13	7.0	3.0	508.0	14.0	3.0	169.333333	5.0	47.075333	0.750000	50.0
5686	13521	1092.39	1.0	4.5	733.0	312.0	3.0	244.333333	145.0	2.511241	0.300000	0.0
5696	15060	301.84	8.0	1.0	262.0	80.0	4.0	65.500000	30.0	2.515333	2.000000	0.0

Overview

Variables

Interactions

Correlations

Missing values

Sample